翻訳と辞書 |
Aggregate function : ウィキペディア英語版 | Aggregate function In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement such as a set, a bag or a list. Common aggregate functions include: *Average() (i.e., arithmetic mean) *Count() *Maximum() *nanmean() (mean ignoring NaN values (or undefined values or 'nil's)) *Median() *Minimum() *Mode() *Sum() Aggregate functions are common in numerous programming languages, spreadsheets, and relational algebra. ==See also==
*Group by (SQL), SQL clause *Online analytical processing *OLAP cube *Fold (higher-order function) *Pivot table *Extract, transform, load *Data drilling *Drill down *Data mining *Data processing *Relational algebra *XML for Analysis *Cross-tabulation a.k.a. Contingency table *Utility functions on indivisible goods#Aggregates of utility functions
抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)』 ■ウィキペディアで「Aggregate function」の詳細全文を読む
スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース |
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.
|
|